﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ExcelFileQueryTool
{
    public enum DBRecordStatus : short
    {
        Normal = 0,
        Deleted = 1
    }

    public enum BillSalesType : short
    {
        /// <summary>
        /// 未定义
        /// </summary>
        NotDefined = 0,
        /// <summary>
        /// 销售(进货退货也算是销售)
        /// </summary>
        Sale = 1,
        /// <summary>
        /// 进货
        /// </summary>
        Purchase = 2,
        /// <summary>
        /// 销售退货
        /// </summary>
        ReturnForSale = 3,
        /// <summary>
        /// 收款/收入
        /// </summary>
        Income = 4,
        /// <summary>
        /// 付款/支出
        /// </summary>
        Pay = 5,
        /// <summary>
        /// 优惠打折
        /// </summary>
        Discount = 6,
        /// <summary>
        /// 损失
        /// </summary>
        Lost = 7
    }

    public sealed class BillSales
    {
        public int? Id { get; set; }

        public int ClientId { get; set; }

        public string ClientName { get; set; }

        public string ShippingAddress { get; set; }

        public DateTime SalesDate { get; set; }

        public int ProductId { get; set; }

        public string ProductName { get; set; }

        public decimal ProductPrice { get; set; }

        public string ProductUnit { get; set; }

        public decimal ProductAmount { get; set; }

        public decimal LoadingFee { get; set; }

        public decimal ShippingFee { get; set; }

        public string ShippingMethod { get; set; }

        public decimal TotalMoney { get; set; }

        public short Status { get; set; }

        public short BillType { get; set; }

        public string BillNumber { get; set; }

        public DateTime CreatedTime { get; set; }

        public DateTime LastUpdatedTime { get; set; }

        public string Note { get; set; }

        public bool IsPaidOff { get; set; }
    }
}
